• [Updated Again!] RedGate SQL Source Control and Team Foundation Service

    Updated: 2012-10-31 13:30:00
    31 Oct 2012 Update 2: Microsoft made Team Foundation Service (formerly TFSPreview) public today!  – Andy 31 Oct 2012 Update 1: SQL Source Control 3.1 is available! - Andy 12 Oct 2012 Update: The SQL Source Control 3.1 update is currently unavailable. I will provide additional updates when this version is re-released. - Andy I am excited that RedGate ’s SQL Source Control now supports connectivity to TFSPreview   Team Foundation Service ,  Microsoft ’s cloud-based Application Life Cycle...(read more)

  • CUBEMEMBER and CUBEVALUE stop working after #PowerPivot upgrade to #Excel 2013

    Updated: 2012-10-31 08:38:00
    I found an issue upgrading an Excel workbook containing PowerPivot data from Excel 2010 to Excel 2013. All CUBEMEMBER and CUBEVALUE functions point to a cube name that has been changed between the two version – you have to no longer reference the PowerPivot Data name, replacing it with ThisWorkbookDataModel instead. I wrote an article describing the change that you have to manually make to these Excel formulas in this article on SQLBI web site.

  • SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video

    Updated: 2012-10-31 01:30:51
    Copy data from one table to another table is one of the most requested questions on forums, Facebook and Twitter. The question has come in many formats and there are places I have seen developers are using cursor instead of this direct method. Earlier I have written the similar article a few years ago - SQL [...]

  • Suggestion: ALLFILES option for RESTORE

    Updated: 2012-10-30 23:36:00
    : THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in The Bit Bucket Greg Low IDisposable Entire Site Search Home Blogs Downloads Opml The Bit Bucket Greg Low IDisposable Ramblings of Greg Low SQL Server MVP , MCM and Microsoft RD SQL Down Under Suggestion : ALLFILES option for RESTORE The default action when performing a backup is to append to the backup file yet the default action when restoring a backup is to restore just the first . file I constantly come across customer situations where they are puzzled that they seem to have lost data after they have completed a restore . Invariably , it's just that they haven't restored all the backups contained within a single OS file . This happens most commonly with log backups but also

  • Cloud Computing - just get started already!

    Updated: 2012-10-30 14:43:27
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Buck Woody Entire Site Search Home Blogs Downloads Opml Buck Woody Carpe Datum Cloud Computing just get started already OK you've been hearing about cloud I really dislike that term , but whatever for over two years . You've equated it with just throwing some VM's in some vendor's datacenter which is certainly part of it , but not the whole story . There's a whole world of wait for it coding out there that you should be working on . If you're a developer , this is just a set of servers with operating systems and the runtime layer like.NET , Java , PHP , etc . that you can deploy code to and have it run . It can expand in a horizontal way , allowing massive and I really , honestly mean

  • SQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL

    Updated: 2012-10-30 01:30:52
    I often see developers trying following syntax while using ORDER BY. SELECT Columns FROM TABLE1 ORDER BY Columns UNION ALL SELECT Columns FROM TABLE2 ORDER BY Columns However the above query will return following error. Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword ‘ORDER’. It is not possible to use two different [...]

  • Insert Or update (aka Replace or Upsert)

    Updated: 2012-10-29 17:29:24
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Davide Mauri Entire Site Search Home Blogs Downloads Opml Davide Mauri A place for my thoughts and experiences on SQL Server , Business Intelligence and NET Insert Or update aka Replace or Upsert The topic is really not new but since it’s the second time in few days that I had to explain it different customers , I think it’s worth to make a post out of . it Many times developers would like to insert a new row in a table or , if the row already exists , update it with new data . MySQL has a specific statement for this action , called : REPLACE http : dev.mysql.com doc refman 5.0 en replace.html or the INSERT ON DUPLICATE KEY UPDATE : option http : dev.mysql.com doc refman 5.0 en

  • [Speaking] PowerShell at the PASS Summit

    Updated: 2012-10-29 14:49:00
    Next week is the annual PASS Summit , the event of the year for those of us in the SQL Server community. We get to see our old friends, make new friends, and learn an amazing amount about SQL Server, and it'll be in Seattle, so it's close to the mother ship. I love having Microsoft close, because it's easier to get to know the people who actually make this amazing product we spend our lives working with. This year I'm fortunate to have been selected to present three sessions. One is a regular session...(read more)

  • SQLAuthority News – Windows Efficiency Tricks and Tips – Personal Technology Tip

    Updated: 2012-10-29 01:30:15
    This is the second post in my series about my favorite Technology Tips, and I wanted to focus on my favorite Microsoft product.  Choosing just one topic to cover was too hard, though.  There are so many interesting things I have to share that I am forced to turn this second installment into a five-part [...]

  • Supermicro motherboards and systems

    Updated: 2012-10-29 00:47:00
    I used to buy SuperMicro exclusively for my own lab. SuperMicro always had a deep lineup of motherboards with almost every conceivable variation. In particular, they had the maximum memory and IO configuration that is desired for database servers. But from around 2006, I became too lazy to source the additional components necessary to complete the system, and switched to Dell PowerEdge Tower servers. Now, I may reconsider as neither Dell or HP are offering the right combination of PCI-E slots. Nor...(read more)

  • Server Systems for SQL Server 2012 per core licensing

    Updated: 2012-10-29 00:40:00
    Until recently, the SQL Server Enterprise Edition per processor (socket) licensing model resulted in only 2 or 3 server system configurations being the preferred choice. Determine the number of sockets: 2, 4 or 8. Then select the processor with the most compute capability at that socket count level. Finally, fill the DIMM sockets with the largest capacity ECC memory module at reasonable cost per GB. Currently this is the 16GB DIMM with a price of $365 on the Dell website, and $240 from Crucial. The...(read more)

  • Database Deployment Cribsheet

    Updated: 2012-10-29 00:00:00
    As part of our long-running Cribsheet series, we asked William to write a guide to deployment that described in general terms what is involved in the deployment of a database application, and the sort of issues that one is likely to come up against.

  • Installing SQL Server 2012 on Windows 2012 Server

    Updated: 2012-10-28 17:00:00
    In Want to Learn SQL Server 2012? I wrote about obtaining a fully-featured version of SQL Server 2012 (Developer Edition). This post represents one way to install SQL Server 2012 Developer Edition on a Hyper-V virtual machine running the Windows 2012 Server Standard Edition operating system. This is by no means exhaustive. My goal in writing this is to help you get a default instance of SQL Server 2012 up and running. I do not cover setting up the Hyper-V virtual machine. I begin after loading the...(read more)

  • SQL SERVER – Move Database Files MDF and LDF to Another Location

    Updated: 2012-10-28 01:30:44
    When a novice DBA or Developer create a database they use SQL Server Management Studio to create new database. Additionally, the T-SQL script to create a database is very easy as well. You can just write CREATE DATABASE DatabaseName and it will create new database for you. The point to remember here is that it [...]

  • Bleeding Edge 2012 – session material

    Updated: 2012-10-27 11:46:00
    As promised, here are the slide deck and demo code I used for my presentation at the Bleeding Edge 2012 conference in Laško, Slovenia. Okay, I promised to have them up by Tuesday or Wednesday at worst, and it is now Saturday – my apologies for the delay. Thanks again to all the attendees of my session. I hope you enjoyed it, and if you have any question then please don’t hesitate to get in touch with me. I had a great time in Slovenia, both during the event and in the after hours. Even if everything...(read more)

  • SQL SERVER – Storing Variable Values in Temporary Array or Temporary List

    Updated: 2012-10-27 02:30:08
    SQL Server does not support arrays or a dynamic length storage mechanism like list. Absolutely there are some clever workarounds and few extra-ordinary solutions but everybody can;t come up with such solution. Additionally, sometime the requirements are very simple that doing extraordinary coding is not required. Here is the simple case. Let us say here [...]

  • SQL SERVER – Introduction to Big Data – Guest Post

    Updated: 2012-10-26 02:30:47
    BIG Data – such a big word – everybody talks about this now a days. It is the word in the database world. In one of the conversation I asked my friend Jasjeet Sigh the same question – what is Big Data? He instantly came up with a very effective write-up.  Jasjeet is working as a [...]

  • SQL SERVER – Last Two Days to Get FREE Book – Joes 2 Pros Certification 70-433

    Updated: 2012-10-25 02:30:49
    Earlier this week we announced that we will be giving away FREE SQL Wait Stats book to everybody who will get SQL Server Joes 2 Pros Combo Kit. We had a fantastic response to the contest. We got an overwhelming response to the offer. We knew there would be a great response but we want [...]

  • SQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video

    Updated: 2012-10-24 02:30:40
    One of the most famous errors related to SQL Server is about connecting to SQL Server itself. Here is how it goes, most of the time developers have worked with SQL Server and knows pretty much every error which they face during development language. However, hardly they install fresh SQL Server. As the installation of [...]

  • CloudSeeder: CLR Stored Procedures For Creating CPU Pressure

    Updated: 2012-10-23 20:49:00
    Sometimes, in the interest of testing various scenarios that your server might encounter, it's useful to be able to quickly simulate some condition or another. I/O, memory, CPU pressure, and so on. This latter one is something I've been playing with a lot recently. CPU pressure in SQL Server creates all sorts of interesting side-effects , such as exacerbating waits and making various other conditions much easier to reproduce. In order to make this simpler, I've created the attached CLR library. This...(read more)

  • Declarative Architectures in Infrastructure as a Service (IaaS)

    Updated: 2012-10-23 15:00:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Buck Woody Entire Site Search Home Blogs Downloads Opml Buck Woody Carpe Datum Declarative Architectures in Infrastructure as a Service IaaS I deal with computing architectures by first laying out requirements , and then laying in any constraints for it's success . Only then do I bring in computing elements to apply to the system . As an example , a requirement might be world-side availability and a constraint might be with less than 80ms response time and full HA or something similar . Then I can choose from the best fit of technologies which range from full-up on-premises computing to IaaS , PaaS or . SaaS I also deal in abstraction layers on-premises systems are fully under your

  • Less Useful Soft Skills

    Updated: 2012-10-23 12:00:00
    Introduction This post is the fifty-sixth part of a ramble-rant about the software business. The current posts in this series can be found on the series landing page . Over a career that spans decades, one encounters useful and “less useful” soft skills in the modern enterprise. I thought I would share a few of the less useful variety: Free Advice If someone asks another for advice, that’s a cool compliment. The person asking has seen something that compels them to seek information about how-another-does-or-sees-things....(read more)

  • SQL SERVER – Order By Numeric Values Formatted as String

    Updated: 2012-10-23 02:30:51
    When I was writing this blog post I had a hard time to come up with the title of the blog post so I did my best to come up with one. Here is the reason why? I wrote a blog post earlier SQL SERVER – Find First Non-Numeric Character from String. One of the [...]

  • SSIS Basics: Using the Execute SQL Task to Generate Result Sets

    Updated: 2012-10-23 01:00:00
    The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning SSIS, or only using it occasionally. What it needed, we felt, was a clear step-by-step guide that showed the basics of how to use it effectively. Annette has once again cleared the fog of confusion

  • Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale

    Updated: 2012-10-23 01:00:00
    Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable, but it is a mixed blessing. It is important to understand the down-side before using table partitioning.

  • Manipulating XML Data in SQL Server

    Updated: 2012-10-23 01:00:00
    When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from SQL, it is often done 'at arms length'. A shame, since effective use of techniques that go beyond the basics can save much code, and are likely to perform better.

  • Want to Learn SQL Server 2012?

    Updated: 2012-10-22 14:00:00
    Or SSIS 2012? SSRS 2012? SSAS 2012? There’s no substitute for getting your hands on the product, in my opinion. I can hear you thinking, “But Andy, I can’t afford to purchase a copy of SQL Server 2012.” Are you sure? What if I told you that you can get a full-feature version of SQL Server 2012 Enterprise Edition for $50? Well, you cannot… it’s actually less than $50! SQL Server 2012 Developer Edition is available at Amazon on the day of this writing for $41.24USD. That’s about the price of eight...(read more)

  • SQL SERVER – Vacation, Travel and Study – A New Concept

    Updated: 2012-10-22 02:30:48
    Quite often when developers go to training sessions they either find it very boring because of study or great because they treat it as a vacation. There should be a perfect balance between study and extra activities. Studying is Boring Studying is very hard. Nobody likes to study, very few people are going to list [...]

  • A proposal for #DAX Code Formatting #ssas #powerpivot #tabular

    Updated: 2012-10-22 01:10:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SQLBI Marco Russo Entire Site Search Home Blogs Downloads Opml SQLBI Marco Russo SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server A proposal for DAX Code Formatting ssas powerpivot tabular I recently published a set of rules for DAX code formatting The following is an example of what I : obtain CALCULATE SUMX Orders , Orders[Amount FILTER ALL Customers CALCULATE COUNTROWS Sales ALL Calendar[Date 42 8 25 3 1 2 1 2 1 CALCULATE 2 2 2 2 2 CALCULATE 4 The goal is to improve code readability and I look forward to implement a code formatting feature in DAX Studio . The DAX Editor already supports the rules described in the article I am also considering

  • SQL Saturday #146 : Nashua, NH

    Updated: 2012-10-21 02:35:00
    Today was SQL Saturday #146, put on by Mike Walsh, Jack Corbett, and a host of other volunteers and organizers. Scott and I missed the speaker dinner last night, but we headed up from Rhode Island at 6:00 AM and made a good day of it. We had lots of great conversations with both existing friends and potential customers. After lunch I participated in a panel discussion with Joey D'Antoni and Andrew Kelly, led my Mike. We basically talked about various things DBAs are responsible for - and ultimately...(read more)

  • SQLAuthority News – Windows Azure Training Kit Updated October 2012

    Updated: 2012-10-21 02:30:23
    Microsoft has recently released the updated to Windows Azure Training Kit. Earlier this month they have updated the kit and included quite a lot of things. Now the training kit contains 47 hands-on labs, 24 demos and 38 presentations. The best part is that the kit is now available to download in two different formats 1) [...]

  • Updates to Stairway to Integration Services

    Updated: 2012-10-20 04:02:25
    The Stairway to integration Services has been updated! I added content to Step 1 to provide more detail about creating a first SSIS project and corrected a typo in Step 2 that referred to an older name for the Step 1 article. I also made the corrected Step 1 article name a link to help. Thanks to Steve Jones ( blog | @way0utwest ) for all his hard work editing and corralling trifling authors. :{>...(read more)

  • SQLAuthority News – Who I Am And How I Got Here – True Story as Blog Post

    Updated: 2012-10-20 02:30:16
    Here are few of the sample questions I get every day? “Give me shortcut to become superstar?” “How do I become like you?” “Which book I should read so I know everything?” “Can you share your secret to be successful? I want to know it but do not share with others.” There is generic answer [...]

  • Conquer Your Fear of Virtualization with a Free Day of Training at PASS!

    Updated: 2012-10-18 17:50:00
    Get tons of free training from House of Brick, one of the USA's top database and virtualization consultancies, at the 2012 PASS Summit!...(read more)

  • Blog Posts from Prepping for Last Year's Summit

    Updated: 2012-10-18 11:58:00
    Last year, I had a series of blog posts that matched up with a webcast I did targeting First Timers to the PASS Summit 2011. Here is a link to the final blog post which is a summary of those posts and links to the main points in the series. A good deal of the information in those posts are still relevant. I am in the process of updating the webcast and will be presenting the information again this year on Oct 25, 2012 at 11am ET. There is a lot of great information out there for first timers that...(read more)

  • SQL SERVER – Finding Different ColumnName From Almost Identitical Tables

    Updated: 2012-10-18 02:30:30
    I have mentioned earlier on this blog that I love social media – Facebook and Twitter. I receive so many interesting questions that sometimes I wonder how come I never faced them in my real life scenario. Well, let us see one of the similar situation. Here is one of the questions which I received [...]

  • SQL Server devs–what source control system do you use, if any? (answer and maybe win free stuff)

    Updated: 2012-10-18 01:48:32
    , THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SSIS Junkie Entire Site Search Home Blogs Downloads Opml SSIS Junkie This is the blog of Jamie Thomson , a freelance SQL Server developer in London SQL Server devs–what source control system do you use , if any answer and maybe win free stuff Recently I noticed a tweet from notable SQL Server author and community dude-at-large Steve Jones in which he asked how many SQL Server developers were putting their SQL Server source code i.e . DDL under source control I’m paraphrasing because I can’t remember the exact tweet and Twitter’s search functionality is useless The question surprised me slightly as I thought a more pertinent question would be how many SQL Server developers are not

  • HTML Maps for DataViz

    Updated: 2012-10-17 16:16:07
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SSIS Junkie Entire Site Search Home Blogs Downloads Opml SSIS Junkie This is the blog of Jamie Thomson , a freelance SQL Server developer in London HTML Maps for DataViz I don’t talk about data visualisation dataviz much on this blog because , well , because its not something I can claim to be particularly knowledgeable about that doesn’t stop me from having an opinion about it . though I just stumbled upon an article that compares the media ecosystems of four various technology companies entitled Mapping The Entertainment Ecosystems of Apple , Microsoft , Google Amazon and apart from being a well-researched and well-written article not something that the tech press excels in , in my

  • Querying the SSIS Catalog? Here’s a handy query!

    Updated: 2012-10-17 01:05:57
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SSIS Junkie Entire Site Search Home Blogs Downloads Opml SSIS Junkie This is the blog of Jamie Thomson , a freelance SQL Server developer in London Querying the SSIS Catalog Here’s a handy query I’ve been working on a SQL Server Integration Services SSIS solution for about 6 months now and I’ve learnt many many things that I intend to share on this blog just as soon as I get the time . Here’s a very short starter-for-ten I’ve found the following query to be utterly invaluable when interrogating the SSIS Catalog to discover what is going on in my : executions SELECT event_message_id MESSAGE package_name event_name message_source_name package_path execution_path message_type

  • Search For a Query in RDL Files with PowerShell

    Updated: 2012-10-16 19:58:00
    In tracking down poorly performing queries for clients I often encounter the query text in a trace file I've captured, but don't know the source of the query. I've found that many of the poorest performing queries are those written into the reports the business users need to make their decisions. If I can't figure out where they came from, usually years after the queries were written, I can't fix them. First thing I did was find a great utility called RSScripter , which opens up a Windows dialog...(read more)

  • Is Data Science “Science”?

    Updated: 2012-10-16 14:29:03
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Buck Woody Entire Site Search Home Blogs Downloads Opml Buck Woody Carpe Datum Is Data Science Science” I hold the term science in very high esteem . I grew up on the Space Coast in Florida , and eventually worked at the Kennedy Space Center , surrounded by very intelligent people who worked in various scientific . fields Recently a new term has entered the computing dialog Data Scientist Since it's not a standard term , it has a lot of definitions , and in fact has been disputed as a correct term . After all , the reasoning goes , if there's no such thing as Data Science then how can there be a Data Scientist This argument has been made before , albeit with a different term Computer

  • SQL SERVER – Free Print Book on SQL Server Joes 2 Pros Kit

    Updated: 2012-10-15 02:30:02
    Rick Morelan and I were discussing earlier this month that what we can give back to the community. We believe our books are very much successful and very well received by the community. The five books are a journey from novice to expert. The books have changed many lives and helped many get jobs as [...]

  • Designing Databases for Rapid Resilience

    Updated: 2012-10-15 01:00:00
    As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure. For this, the intelligent use of filegroups is important, particularly when the Enterprise Edition of SQL Server offers the hope of online restores. How, though, should you arrange your data on the different filegroups? What happenens if the primary filegroup gets corrupted? Why backup and restore indexes?

  • SQL SERVER – Find First Non-Numeric Character from String

    Updated: 2012-10-14 02:30:15
    It is fun when you have to deal with simple problems and there are no out of the box solution. I am sure there are many cases when we needed the first non-numeric character from the string but there is no function available to identify that right away. Here is the quick script I wrote [...]

  • SQL SERVER – 2012 – List All The Column With Specific Data Types in Database

    Updated: 2012-10-13 02:30:44
    5 years ago I wrote script SQL SERVER – 2005 – List All The Column With Specific Data Types, when I read it again, it is very much relevant and I liked it. This is one of the script which every developer would like to keep it handy. I have upgraded the script bit more. [...]

  • SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market

    Updated: 2012-10-12 02:30:38
    There has been much fanfare over the new SQL Server 2012, and especially around its new companion product Data Quality Services (DQS). Among the many new features is the addition of this integrated knowledge-driven product that enables data stewards everywhere to profile, match, and cleanse data. In addition to the homegrown rules that data stewards [...]

  • SQLAuthority News – Amazon Gift Card Raffle for Beta Tester Feedback for NuoDB

    Updated: 2012-10-11 02:30:39
    As regular readers know I’ve been spending some time working with the NuoDB beta software. They contacted me last week and asked if I would give you a chance to try their new web-based console for their scalable, SQL-compliant database. They have just put out their final beta release, Beta 9.  It contains a preview [...]

  • Tune Your Indexing Strategy with SQL Server DMVs

    Updated: 2012-10-11 01:00:00
    SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you create must ensure that the workload reads the data quickly with a minimum of I/O. As well as a sound knowledge of the way that relational databases work, it helps to be familiar with the Dynamic Management Objects that are there to assist with your indexing strategy.

  • SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #029 – Video

    Updated: 2012-10-10 02:30:38
    There are a few questions I often get asked. I wonder how interesting is that in our daily life all of us have to often need the same kind of information at the same time. Here is the example of the similar questions: How many user created tables are there in the database? How many non [...]

  • Database Source Control Basics: The Unified Solution

    Updated: 2012-10-09 08:00:00
    It isn't easy to use source control effectively for a database project unless you have a single solution that covers both your application files and your database, but which also allows you direct access from the file system. As always, it is the detail that can trip you up.

  • SQL SERVER – Identify Numbers of Non Clustered Index on Tables for Entire Database

    Updated: 2012-10-09 02:30:26
    Here is the script which will give you numbers of non clustered indexes on any table in entire database. SELECT COUNT(i.TYPE) NoOfIndex, [schema_name] = s.name, table_name = o.name FROM sys.indexes i INNER JOIN sys.objects o ON i.[object_id] = o.[object_id] INNER JOIN sys.schemas s ON o.[schema_id] = s.[schema_id] WHERE o.TYPE IN ('U') AND i.TYPE = 2 [...]

  • Database Source Control Basics: The Essential Operations

    Updated: 2012-10-09 01:03:00
    Database Source Control operates much like a conventional file-based source control, particularly with the Commit and Update operations. The complexities of applying updates to databases, doing rollbacks and deployment, come from the requirement to preserve the data in the database and ensure that it goes in the right place as the schema changes

  • Database Source Control Basics: Getting Started

    Updated: 2012-10-09 01:00:00
    It makes a lot of sense to do it, but how do you get started? Whatever you use to build Applications with SQL Server, there is a good way of using source control and many reasons for doing so.

  • Exploring Semantic Search Key Term Relevance

    Updated: 2012-10-09 01:00:00
    SQL Server's 'Semantic Search' feature seemed an exciting feature when first shown. Was it really true that Microsoft had come up with a system to rival the industry-leaders, one that could extract the contextual meaning of terms in text, or automatically categorise the subject matter of text? On first inspection, it seems unlikely.

  • I'll be speaking at SQLServerDays in Antwerp in November

    Updated: 2012-10-08 17:00:00
    Home Syndication Log in I'll be speaking at SQLServerDays in Antwerp in November I'm honored to be invited to speak at SQLServerDays Nov 19-20, in Schelle Belgium , just outside of Antwerp . I've been to Belgium before , but this is my first time in Antwerp and I'm really looking forward to it . I'll be doing a day-long precon on Nov 19 on New Features in SQL Server 2012. And following up on Tuesday with talks on two of my favorite topics : Spatial Data and SQL Performance , both about the improvements on SQL Server 2012. Looking forward to catching up with old friends the Belgian folks were always kind and invited me to their country party at TechEds over the years and meeting up with some new friends . And they'll be lots of great speakers at this conference . If you're around Monday and

Current Feed Items | Previous Months Items

Sep 2012 | Aug 2012 | Jul 2012 | Jun 2012 | May 2012 | Apr 2012